package com.example.demo.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * @author lizijian
 */
@Mapper
public interface ManagerDao {


  @Insert("INSERT INTO course_classroom (campus_id,`name`,building) VALUES(#{campusId},#{name},#{building})")
  void insertCourseClassRoom(@Param("campusId") Integer campusId,@Param("name") String name,@Param("building") String building);

  @Insert("INSERT INTO hbut_teacher_course (teacher_name,course_name,classes,weeks,day,lesson,classroom) VALUES(#{teacherName},"
      + "#{courseName},#{classes},#{weeks},#{day},#{lesson},#{classroom})")
  void insertTeacherCourse(@Param("teacherName") String teacherName,@Param("courseName") String courseName,@Param("classes") String classes,
      @Param("weeks") String weeks,@Param("day") int day,@Param("lesson") int lesson,@Param("classroom") String classroom);



  @Insert("INSERT INTO optional_course (course_name,teacher_name,weeks,address,day,lesson) VALUES (#{courseName},#{teacherName},#{weeks},#{address},#{day},#{lesson})")
  void addOptionalCourse(@Param("courseName") String courseName,@Param("teacherName") String teacherName
      ,@Param("weeks") String weeks,@Param("address") String address,@Param("day") int day,@Param("lesson") int lesson);


}
